Best Tech Reads

#All_Posts

Step by step guide to becoming a modern PostgreSQL DB Administrator in 2023

byKishore Uppala -7/05/2023 11:03:00 PM

Roadmap:  https://roadmap.sh/postgresql-dba Credits to: https://roadmap.sh/postgresql-dba DISCLA…

#All_Posts

Customizing Your PostgreSQL Prompt: How to Set a Colorful and Eye-Catching psql Prompt

byKishore Uppala -3/04/2023 11:19:00 AM

The psql interactive command line prompt can be customized through the psqlrc file, which come…

#All_Posts

Postgres Parameter Changes: Know When to Restart and When to Reload Postgres Service

byKishore Uppala -3/03/2023 11:07:00 PM

There are several possible context values. To reduce the difficulty of changing the settings, th…

#Day_To_Day_Activities

Step by Step to install PostgreSQL 15 with a custom data directory and enable checksums on CentOS 7

byKishore Uppala -2/11/2023 11:38:00 PM

Step by Step to install PostgreSQL  with a custom data directory and enable checksums on CentOS …

#All_Posts

Steps To Perform Restore and Recovery in PostgreSQL12

byKishore Uppala -11/13/2022 11:51:00 AM

Backup Command: /usr/pgsql-12/bin/pg_basebackup -r 1024 --wal-method=stream -h localhost -p 5432…